Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	1586614
Missing cells	68148
Missing cells (%)	0.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	567.8 MiB
Average record size in memory	375.3 B

Variable types

NUM	9
CAT	4

Reproduction

Analysis started	2021-02-26 05:26:30.582051
Analysis finished	2021-02-26 05:28:46.240468
Duration	2 minutes and 15.66 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`brewery_name` has a high cardinality: 5742 distinct values	High cardinality
`review_profilename` has a high cardinality: 33387 distinct values	High cardinality
`beer_style` has a high cardinality: 104 distinct values	High cardinality
`beer_name` has a high cardinality: 56857 distinct values	High cardinality
`beer_abv` has 67785 (4.3%) missing values	Missing

brewery_id
Real number (ℝ_≥0)

Distinct count	5840
Unique (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3130.0992018222455
Minimum	1
Maximum	28003
Zeros	0
Zeros (%)	0.0%
Memory size	12.1 MiB

Quantile statistics

Minimum	1
5-th percentile	30
Q1	143
median	429
Q3	2372
95-th percentile	16866
Maximum	28003
Range	28002
Interquartile range (IQR)	2229

Descriptive statistics

Standard deviation	5578.103987
Coefficient of variation (CV)	1.782085368
Kurtosis	3.408354127
Mean	3130.099202
Median Absolute Deviation (MAD)	366
Skewness	2.083747568
Sum	4966259215
Variance	31115244.1

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
35	39444	2.5%
10099	33839	2.1%
147	33066	2.1%
140	28751	1.8%
287	25191	1.6%
132	24083	1.5%
1199	20004	1.3%
345	19479	1.2%
220	16837	1.1%
30	16107	1.0%
3818	15868	1.0%
29	15815	1.0%
158	14935	0.9%
1549	14534	0.9%
26	14039	0.9%
22	13921	0.9%
45	13902	0.9%
192	13410	0.8%
392	12248	0.8%
694	11842	0.7%
68	11697	0.7%
863	11311	0.7%
112	11280	0.7%
590	11172	0.7%
73	10943	0.7%
Other values (5815)	1132896	71.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1357	0.1%
2	40	< 0.1%
3	5357	0.3%
4	7321	0.5%
5	728	< 0.1%
6	367	< 0.1%
8	3775	0.2%
9	897	0.1%
10	56	< 0.1%
11	23	< 0.1%

Value	Count	Frequency (%)
28003	2	< 0.1%
28000	1	< 0.1%
27984	1	< 0.1%
27980	3	< 0.1%
27945	1	< 0.1%
27944	1	< 0.1%
27934	4	< 0.1%
27927	2	< 0.1%
27922	3	< 0.1%
27920	1	< 0.1%

brewery_name
Categorical

HIGH CARDINALITY

Distinct count	5742
Unique (%)	0.4%
Missing	15
Missing (%)	< 0.1%
Memory size	12.1 MiB

Boston Beer Company (Samuel Adams)	39444
Dogfish Head Brewery	33839
Stone Brewing Co.	33066
Sierra Nevada Brewing Co.	28751
Bell's Brewery, Inc.	25191
Other values (5737)	1426308

Value	Count	Frequency (%)
Boston Beer Company (Samuel Adams)	39444	2.5%
Dogfish Head Brewery	33839	2.1%
Stone Brewing Co.	33066	2.1%
Sierra Nevada Brewing Co.	28751	1.8%
Bell's Brewery, Inc.	25191	1.6%
Rogue Ales	24083	1.5%
Founders Brewing Company	20004	1.3%
Victory Brewing Company	19479	1.2%
Lagunitas Brewing Company	16837	1.1%
Avery Brewing Company	16107	1.0%
Southern Tier Brewing Company	15868	1.0%
Anheuser-Busch	15815	1.0%
Great Divide Brewing Company	14935	0.9%
Goose Island Beer Co.	14534	0.9%
Three Floyds Brewing Co. & Brewpub	14039	0.9%
Unibroue	13921	0.9%
Brooklyn Brewery	13902	0.9%
New Belgium Brewing	13410	0.8%
Weyerbacher Brewing Co.	12248	0.8%
Tröegs Brewing Company	11842	0.7%
Flying Dog Brewery	11697	0.7%
Russian River Brewing Company	11311	0.7%
North Coast Brewing Co.	11280	0.7%
New Glarus Brewing Company	11172	0.7%
Great Lakes Brewing Company	10943	0.7%
Other values (5717)	1132881	71.4%

Length

Max length	66
Median length	23
Mean length	23.61012761
Min length	3

Overview of Unicode Properties

Unique unicode characters	132
Unique unicode categories (?)	12
Unique unicode scripts (?)	2
Unique unicode blocks (?)	3

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
e	3939975	10.5%
	3931498	10.5%
r	3198978	8.5%
n	2341465	6.3%
a	2041873	5.5%
o	2009863	5.4%
i	1909456	5.1%
B	1714210	4.6%
w	1306627	3.5%
s	1172755	3.1%
g	1135712	3.0%
y	1133858	3.0%
C	989535	2.6%
t	971015	2.6%
m	910208	2.4%
l	901726	2.4%
u	805557	2.2%
p	727846	1.9%
d	560363	1.5%
h	498253	1.3%
.	469257	1.3%
S	417502	1.1%
c	360006	1.0%
A	304760	0.8%
b	261067	0.7%
Other values (107)	3446794	9.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	26990410	72.1%
Uppercase Letter	5508479	14.7%
Space Separator	3931502	10.5%
Other Punctuation	809694	2.2%
Open Punctuation	69272	0.2%
Close Punctuation	69272	0.2%
Dash Punctuation	56826	0.2%
Decimal Number	22848	0.1%
Control	855	< 0.1%
Final Punctuation	720	< 0.1%
Math Symbol	270	< 0.1%
Modifier Symbol	11	< 0.1%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
B	1714210	31.1%
C	989535	18.0%
S	417502	7.6%
A	304760	5.5%
H	193868	3.5%
L	191839	3.5%
D	178746	3.2%
T	171416	3.1%
G	164219	3.0%
P	159544	2.9%
R	144150	2.6%
F	133391	2.4%
M	127101	2.3%
N	121188	2.2%
W	99740	1.8%
V	83080	1.5%
I	82387	1.5%
O	68420	1.2%
K	53306	1.0%
E	30409	0.6%
U	29553	0.5%
J	26590	0.5%
Y	14178	0.3%
Z	3828	0.1%
Ø	3438	0.1%
Other values (12)	2081	< 0.1%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
e	3939975	14.6%
r	3198978	11.9%
n	2341465	8.7%
a	2041873	7.6%
o	2009863	7.4%
i	1909456	7.1%
w	1306627	4.8%
s	1172755	4.3%
g	1135712	4.2%
y	1133858	4.2%
t	971015	3.6%
m	910208	3.4%
l	901726	3.3%
u	805557	3.0%
p	727846	2.7%
d	560363	2.1%
h	498253	1.8%
c	360006	1.3%
b	261067	1.0%
k	240430	0.9%
v	187746	0.7%
f	120672	0.4%
j	95259	0.4%
z	61404	0.2%
ä	24216	0.1%
Other values (32)	74080	0.3%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	3931498	> 99.9%
	4	< 0.1%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
.	469257	58.0%
&	118017	14.6%
'	99610	12.3%
/	63031	7.8%
,	51456	6.4%
#	4052	0.5%
;	4000	0.5%
?	144	< 0.1%
"	81	< 0.1%
@	46	< 0.1%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
2	6832	29.9%
1	4501	19.7%
3	3349	14.7%
8	1795	7.9%
5	1673	7.3%
7	1471	6.4%
6	1423	6.2%
4	727	3.2%
0	567	2.5%
9	510	2.2%

Most frequent Dash Punctuation characters

Value	Count	Frequency (%)
-	56826	100.0%

Most frequent Open Punctuation characters

Value	Count	Frequency (%)
(	69246	> 99.9%
[	26	< 0.1%

Most frequent Close Punctuation characters

Value	Count	Frequency (%)
)	69246	> 99.9%
]	26	< 0.1%

Most frequent Control characters

Value	Count	Frequency (%)
	640	74.9%
	180	21.1%
	24	2.8%
	5	0.6%
	2	0.2%
	2	0.2%
	2	0.2%

Most frequent Modifier Symbol characters

Value	Count	Frequency (%)
´	7	63.6%
`	4	36.4%

Most frequent Final Punctuation characters

Value	Count	Frequency (%)
’	720	100.0%

Most frequent Math Symbol characters

Value	Count	Frequency (%)
+	270	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	32498889	86.8%
Common	4961270	13.2%

Most frequent Latin characters

Value	Count	Frequency (%)
e	3939975	12.1%
r	3198978	9.8%
n	2341465	7.2%
a	2041873	6.3%
o	2009863	6.2%
i	1909456	5.9%
B	1714210	5.3%
w	1306627	4.0%
s	1172755	3.6%
g	1135712	3.5%
y	1133858	3.5%
C	989535	3.0%
t	971015	3.0%
m	910208	2.8%
l	901726	2.8%
u	805557	2.5%
p	727846	2.2%
d	560363	1.7%
h	498253	1.5%
S	417502	1.3%
c	360006	1.1%
A	304760	0.9%
b	261067	0.8%
k	240430	0.7%
H	193868	0.6%
Other values (69)	2451981	7.5%

Most frequent Common characters

Value	Count	Frequency (%)
	3931498	79.2%
.	469257	9.5%
&	118017	2.4%
'	99610	2.0%
(	69246	1.4%
)	69246	1.4%
/	63031	1.3%
-	56826	1.1%
,	51456	1.0%
2	6832	0.1%
1	4501	0.1%
#	4052	0.1%
;	4000	0.1%
3	3349	0.1%
8	1795	< 0.1%
5	1673	< 0.1%
7	1471	< 0.1%
6	1423	< 0.1%
4	727	< 0.1%
’	720	< 0.1%
	640	< 0.1%
0	567	< 0.1%
9	510	< 0.1%
+	270	< 0.1%
	180	< 0.1%
Other values (13)	373	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	37376792	99.8%
None	82647	0.2%
Punctuation	720	< 0.1%

Most frequent ASCII characters

Value	Count	Frequency (%)
e	3939975	10.5%
	3931498	10.5%
r	3198978	8.6%
n	2341465	6.3%
a	2041873	5.5%
o	2009863	5.4%
i	1909456	5.1%
B	1714210	4.6%
w	1306627	3.5%
s	1172755	3.1%
g	1135712	3.0%
y	1133858	3.0%
C	989535	2.6%
t	971015	2.6%
m	910208	2.4%
l	901726	2.4%
u	805557	2.2%
p	727846	1.9%
d	560363	1.5%
h	498253	1.3%
.	469257	1.3%
S	417502	1.1%
c	360006	1.0%
A	304760	0.8%
b	261067	0.7%
Other values (55)	3363427	9.0%

Most frequent None characters

Value	Count	Frequency (%)
ä	24216	29.3%
ö	15340	18.6%
è	8006	9.7%
ø	6231	7.5%
é	5753	7.0%
í	4427	5.4%
ü	4010	4.9%
Ø	3438	4.2%
ô	3009	3.6%
ý	1538	1.9%
á	1208	1.5%
š	871	1.1%
	640	0.8%
à	462	0.6%
Ö	380	0.5%
å	377	0.5%
î	350	0.4%
Š	259	0.3%
ñ	210	0.3%
ó	196	0.2%
	180	0.2%
Ž	180	0.2%
ê	161	0.2%
À	159	0.2%
ß	149	0.2%
Other values (26)	897	1.1%

Most frequent Punctuation characters

Value	Count	Frequency (%)
’	720	100.0%

review_time
Real number (ℝ_≥0)

Distinct count	1577960
Unique (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1224089280.0122108
Minimum	840672001
Maximum	1326285348
Zeros	0
Zeros (%)	0.0%
Memory size	12.1 MiB

Quantile statistics

Minimum	840672001
5-th percentile	1071431292
Q1	1173224188
median	1239202882
Q3	1288568405
95-th percentile	1318389924
Maximum	1326285348
Range	485613347
Interquartile range (IQR)	115344217

Descriptive statistics

Standard deviation	76544274.54
Coefficient of variation (CV)	0.06253161088
Kurtosis	-0.3136982976
Mean	1224089280
Median Absolute Deviation (MAD)	54219357.5
Skewness	-0.7352727768
Sum	1.942157189e+15
Variance	5.859025965e+15

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1101772800	21	< 0.1%
1031101200	8	< 0.1%
926380801	8	< 0.1%
897091201	7	< 0.1%
1022112001	7	< 0.1%
980812801	7	< 0.1%
904867201	6	< 0.1%
933033601	6	< 0.1%
902966401	6	< 0.1%
926294401	5	< 0.1%
984787201	5	< 0.1%
926985601	5	< 0.1%
969580801	5	< 0.1%
1022374801	4	< 0.1%
926726401	4	< 0.1%
894931201	4	< 0.1%
933638401	4	< 0.1%
1214439821	4	< 0.1%
969753601	4	< 0.1%
904953601	4	< 0.1%
1247356800	4	< 0.1%
1002499201	4	< 0.1%
887846401	4	< 0.1%
999388801	4	< 0.1%
895276801	3	< 0.1%
Other values (1577935)	1586471	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
840672001	1	< 0.1%
884390401	1	< 0.1%
884649601	1	< 0.1%
885340801	1	< 0.1%
885427201	1	< 0.1%
885945601	1	< 0.1%
886723201	1	< 0.1%
887068801	2	< 0.1%
887155201	2	< 0.1%
887414401	2	< 0.1%

Value	Count	Frequency (%)
1326285348	1	< 0.1%
1326284970	1	< 0.1%
1326276656	1	< 0.1%
1326275049	1	< 0.1%
1326274454	1	< 0.1%
1326273710	1	< 0.1%
1326273614	1	< 0.1%
1326273106	1	< 0.1%
1326272438	1	< 0.1%
1326272107	1	< 0.1%

review_overall
Real number (ℝ_≥0)

Distinct count	10
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.8155808533140387
Minimum	0.0
Maximum	5.0
Zeros	7
Zeros (%)	< 0.1%
Memory size	12.1 MiB

Quantile statistics

Minimum	0
5-th percentile	2.5
Q1	3.5
median	4
Q3	4.5
95-th percentile	5
Maximum	5
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.7206218681
Coefficient of variation (CV)	0.1888629532
Kurtosis	1.631038958
Mean	3.815580853
Median Absolute Deviation (MAD)	0.5
Skewness	-1.023968713
Sum	6053854
Variance	0.5192958767

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4	582764	36.7%
4.5	324385	20.4%
3.5	301817	19.0%
3	165644	10.4%
5	91320	5.8%
2.5	58523	3.7%
2	38225	2.4%
1.5	12975	0.8%
1	10954	0.7%
0	7	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7	< 0.1%
1	10954	0.7%
1.5	12975	0.8%
2	38225	2.4%
2.5	58523	3.7%
3	165644	10.4%
3.5	301817	19.0%
4	582764	36.7%
4.5	324385	20.4%
5	91320	5.8%

Value	Count	Frequency (%)
5	91320	5.8%
4.5	324385	20.4%
4	582764	36.7%
3.5	301817	19.0%
3	165644	10.4%
2.5	58523	3.7%
2	38225	2.4%
1.5	12975	0.8%
1	10954	0.7%
0	7	< 0.1%

review_aroma
Real number (ℝ_≥0)

Distinct count	9
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.735636077836197
Minimum	1.0
Maximum	5.0
Zeros	0
Zeros (%)	0.0%
Memory size	12.1 MiB

Quantile statistics

Minimum	1
5-th percentile	2.5
Q1	3.5
median	4
Q3	4
95-th percentile	4.5
Maximum	5
Range	4
Interquartile range (IQR)	0.5

Descriptive statistics

Standard deviation	0.6976167288
Coefficient of variation (CV)	0.1867464374
Kurtosis	1.145196752
Mean	3.735636078
Median Absolute Deviation (MAD)	0.5
Skewness	-0.838530526
Sum	5927012.5
Variance	0.4866691003

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4	557383	35.1%
3.5	365312	23.0%
4.5	271450	17.1%
3	200030	12.6%
2.5	66359	4.2%
5	64117	4.0%
2	42566	2.7%
1.5	12524	0.8%
1	6873	0.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	6873	0.4%
1.5	12524	0.8%
2	42566	2.7%
2.5	66359	4.2%
3	200030	12.6%
3.5	365312	23.0%
4	557383	35.1%
4.5	271450	17.1%
5	64117	4.0%

Value	Count	Frequency (%)
5	64117	4.0%
4.5	271450	17.1%
4	557383	35.1%
3.5	365312	23.0%
3	200030	12.6%
2.5	66359	4.2%
2	42566	2.7%
1.5	12524	0.8%
1	6873	0.4%

review_appearance
Real number (ℝ_≥0)

Distinct count	10
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.8416416973504584
Minimum	0.0
Maximum	5.0
Zeros	7
Zeros (%)	< 0.1%
Memory size	12.1 MiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	3.5
median	4
Q3	4
95-th percentile	4.5
Maximum	5
Range	5
Interquartile range (IQR)	0.5

Descriptive statistics

Standard deviation	0.6160927689
Coefficient of variation (CV)	0.160372262
Kurtosis	1.738866541
Mean	3.841641697
Median Absolute Deviation (MAD)	0.5
Skewness	-0.9024199172
Sum	6095202.5
Variance	0.3795702999

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4	674186	42.5%
3.5	318529	20.1%
4.5	288108	18.2%
3	166009	10.5%
5	65398	4.1%
2.5	39493	2.5%
2	25414	1.6%
1.5	6147	0.4%
1	3323	0.2%
0	7	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7	< 0.1%
1	3323	0.2%
1.5	6147	0.4%
2	25414	1.6%
2.5	39493	2.5%
3	166009	10.5%
3.5	318529	20.1%
4	674186	42.5%
4.5	288108	18.2%
5	65398	4.1%

Value	Count	Frequency (%)
5	65398	4.1%
4.5	288108	18.2%
4	674186	42.5%
3.5	318529	20.1%
3	166009	10.5%
2.5	39493	2.5%
2	25414	1.6%
1.5	6147	0.4%
1	3323	0.2%
0	7	< 0.1%

review_profilename
Categorical

HIGH CARDINALITY

Distinct count	33387
Unique (%)	2.1%
Missing	348
Missing (%)	< 0.1%
Memory size	12.1 MiB

northyorksammy	5817
BuckeyeNation	4661
mikesgroove	4617
Thorpe429	3518
womencantsail	3497
Other values (33382)	1564156

Value	Count	Frequency (%)
northyorksammy	5817	0.4%
BuckeyeNation	4661	0.3%
mikesgroove	4617	0.3%
Thorpe429	3518	0.2%
womencantsail	3497	0.2%
NeroFiddled	3488	0.2%
ChainGangGuy	3471	0.2%
brentk56	3357	0.2%
Phyl21ca	3179	0.2%
WesWes	3168	0.2%
oberon	3128	0.2%
feloniousmonk	3081	0.2%
akorsak	3010	0.2%
BEERchitect	2946	0.2%
Gueuzedude	2938	0.2%
jwc215	2735	0.2%
russpowell	2696	0.2%
TheManiacalOne	2659	0.2%
Gavage	2630	0.2%
zeff80	2622	0.2%
Mora2000	2594	0.2%
tempest	2559	0.2%
Wasatch	2541	0.2%
WVbeergeek	2524	0.2%
drabmuh	2481	0.2%
Other values (33362)	1506349	94.9%

Length

Max length	16
Median length	9
Mean length	8.961438636
Min length	3

Overview of Unicode Properties

Unique unicode characters	63
Unique unicode categories (?)	4
Unique unicode scripts (?)	2
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
e	1456336	10.2%
a	1059435	7.5%
r	1013118	7.1%
o	866721	6.1%
n	764711	5.4%
i	718329	5.1%
t	631230	4.4%
s	598952	4.2%
l	570628	4.0%
d	445265	3.1%
h	396979	2.8%
m	396390	2.8%
c	395528	2.8%
u	384204	2.7%
b	356292	2.5%
g	326364	2.3%
k	303079	2.1%
y	280820	2.0%
p	236254	1.7%
w	179992	1.3%
1	170728	1.2%
B	166179	1.2%
f	164045	1.2%
j	127289	0.9%
0	126244	0.9%
Other values (38)	2083232	14.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	11923055	83.9%
Uppercase Letter	1348320	9.5%
Decimal Number	946848	6.7%
Other Punctuation	121	< 0.1%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
e	1456336	12.2%
a	1059435	8.9%
r	1013118	8.5%
o	866721	7.3%
n	764711	6.4%
i	718329	6.0%
t	631230	5.3%
s	598952	5.0%
l	570628	4.8%
d	445265	3.7%
h	396979	3.3%
m	396390	3.3%
c	395528	3.3%
u	384204	3.2%
b	356292	3.0%
g	326364	2.7%
k	303079	2.5%
y	280820	2.4%
p	236254	2.0%
w	179992	1.5%
f	164045	1.4%
j	127289	1.1%
v	106435	0.9%
z	87630	0.7%
x	44088	0.4%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
1	170728	18.0%
0	126244	13.3%
2	117738	12.4%
7	100599	10.6%
3	87239	9.2%
8	79308	8.4%
9	74969	7.9%
5	67625	7.1%
4	67397	7.1%
6	55001	5.8%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
B	166179	12.3%
S	99905	7.4%
D	92244	6.8%
M	91717	6.8%
T	81794	6.1%
C	79278	5.9%
G	72979	5.4%
J	64353	4.8%
R	64118	4.8%
A	63561	4.7%
H	57307	4.3%
P	51516	3.8%
F	44635	3.3%
W	41913	3.1%
L	40817	3.0%
N	37390	2.8%
E	34719	2.6%
K	33637	2.5%
O	32379	2.4%
I	28875	2.1%
V	22215	1.6%
Z	15057	1.1%
U	12964	1.0%
Y	9237	0.7%
X	5410	0.4%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
.	121	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	13271375	93.3%
Common	946969	6.7%

Most frequent Latin characters

Value	Count	Frequency (%)
e	1456336	11.0%
a	1059435	8.0%
r	1013118	7.6%
o	866721	6.5%
n	764711	5.8%
i	718329	5.4%
t	631230	4.8%
s	598952	4.5%
l	570628	4.3%
d	445265	3.4%
h	396979	3.0%
m	396390	3.0%
c	395528	3.0%
u	384204	2.9%
b	356292	2.7%
g	326364	2.5%
k	303079	2.3%
y	280820	2.1%
p	236254	1.8%
w	179992	1.4%
B	166179	1.3%
f	164045	1.2%
j	127289	1.0%
v	106435	0.8%
S	99905	0.8%
Other values (27)	1226895	9.2%

Most frequent Common characters

Value	Count	Frequency (%)
1	170728	18.0%
0	126244	13.3%
2	117738	12.4%
7	100599	10.6%
3	87239	9.2%
8	79308	8.4%
9	74969	7.9%
5	67625	7.1%
4	67397	7.1%
6	55001	5.8%
.	121	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14218344	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
e	1456336	10.2%
a	1059435	7.5%
r	1013118	7.1%
o	866721	6.1%
n	764711	5.4%
i	718329	5.1%
t	631230	4.4%
s	598952	4.2%
l	570628	4.0%
d	445265	3.1%
h	396979	2.8%
m	396390	2.8%
c	395528	2.8%
u	384204	2.7%
b	356292	2.5%
g	326364	2.3%
k	303079	2.1%
y	280820	2.0%
p	236254	1.7%
w	179992	1.3%
1	170728	1.2%
B	166179	1.2%
f	164045	1.2%
j	127289	0.9%
0	126244	0.9%
Other values (38)	2083232	14.7%

beer_style
Categorical

HIGH CARDINALITY

Distinct count	104
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.1 MiB

American IPA	117586
American Double / Imperial IPA	85977
American Pale Ale (APA)	63469
Russian Imperial Stout	54129
American Double / Imperial Stout	50705
Other values (99)	1214748

Value	Count	Frequency (%)
American IPA	117586	7.4%
American Double / Imperial IPA	85977	5.4%
American Pale Ale (APA)	63469	4.0%
Russian Imperial Stout	54129	3.4%
American Double / Imperial Stout	50705	3.2%
American Porter	50477	3.2%
American Amber / Red Ale	45751	2.9%
Belgian Strong Dark Ale	37743	2.4%
Fruit / Vegetable Beer	33861	2.1%
American Strong Ale	31945	2.0%
Belgian Strong Pale Ale	31490	2.0%
Saison / Farmhouse Ale	31480	2.0%
American Adjunct Lager	30749	1.9%
Tripel	30328	1.9%
Witbier	30140	1.9%
Hefeweizen	27908	1.8%
American Barleywine	26728	1.7%
American Brown Ale	25297	1.6%
American Stout	24538	1.5%
American Pale Wheat Ale	24204	1.5%
Märzen / Oktoberfest	23523	1.5%
English Pale Ale	23402	1.5%
German Pilsener	22155	1.4%
Doppelbock	21699	1.4%
Winter Warmer	20661	1.3%
Other values (79)	620669	39.1%

Length

Max length	35
Median length	18
Mean length	17.86997972
Min length	4

Overview of Unicode Properties

Unique unicode characters	58
Unique unicode categories (?)	7
Unique unicode scripts (?)	2
Unique unicode blocks (?)	2

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
e	3385494	11.9%
	3109205	11.0%
r	2064180	7.3%
a	1857764	6.6%
i	1740712	6.1%
l	1695737	6.0%
A	1611741	5.7%
n	1489042	5.3%
m	1045719	3.7%
t	1009376	3.6%
c	916530	3.2%
o	857023	3.0%
u	669988	2.4%
P	630283	2.2%
g	514774	1.8%
I	464670	1.6%
S	444824	1.6%
s	424335	1.5%
b	420790	1.5%
B	385738	1.4%
/	375648	1.3%
p	344643	1.2%
h	285034	1.0%
D	268623	0.9%
d	264957	0.9%
Other values (33)	2075930	7.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	19700711	69.5%
Uppercase Letter	4923322	17.4%
Space Separator	3109205	11.0%
Other Punctuation	378006	1.3%
Open Punctuation	114726	0.4%
Close Punctuation	114726	0.4%
Dash Punctuation	12064	< 0.1%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
A	1611741	32.7%
P	630283	12.8%
I	464670	9.4%
S	444824	9.0%
B	385738	7.8%
D	268623	5.5%
E	176337	3.6%
L	151118	3.1%
W	148972	3.0%
R	139836	2.8%
F	94531	1.9%
H	77159	1.6%
M	70050	1.4%
O	61366	1.2%
V	42815	0.9%
G	38330	0.8%
Q	36172	0.7%
T	32686	0.7%
C	29286	0.6%
K	13534	0.3%
Z	2591	0.1%
J	1546	< 0.1%
U	1114	< 0.1%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
e	3385494	17.2%
r	2064180	10.5%
a	1857764	9.4%
i	1740712	8.8%
l	1695737	8.6%
n	1489042	7.6%
m	1045719	5.3%
t	1009376	5.1%
c	916530	4.7%
o	857023	4.4%
u	669988	3.4%
g	514774	2.6%
s	424335	2.2%
b	420790	2.1%
p	344643	1.7%
h	285034	1.4%
d	264957	1.3%
k	205933	1.0%
w	153020	0.8%
z	98744	0.5%
y	80625	0.4%
f	55469	0.3%
j	30749	0.2%
x	27624	0.1%
ä	23523	0.1%
Other values (4)	38926	0.2%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	3109205	100.0%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
/	375648	99.4%
&	2358	0.6%

Most frequent Open Punctuation characters

Value	Count	Frequency (%)
(	114726	100.0%

Most frequent Close Punctuation characters

Value	Count	Frequency (%)
)	114726	100.0%

Most frequent Dash Punctuation characters

Value	Count	Frequency (%)
-	12064	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	24624033	86.8%
Common	3728727	13.2%

Most frequent Latin characters

Value	Count	Frequency (%)
e	3385494	13.7%
r	2064180	8.4%
a	1857764	7.5%
i	1740712	7.1%
l	1695737	6.9%
A	1611741	6.5%
n	1489042	6.0%
m	1045719	4.2%
t	1009376	4.1%
c	916530	3.7%
o	857023	3.5%
u	669988	2.7%
P	630283	2.6%
g	514774	2.1%
I	464670	1.9%
S	444824	1.8%
s	424335	1.7%
b	420790	1.7%
B	385738	1.6%
p	344643	1.4%
h	285034	1.2%
D	268623	1.1%
d	264957	1.1%
k	205933	0.8%
E	176337	0.7%
Other values (27)	1449786	5.9%

Most frequent Common characters

Value	Count	Frequency (%)
	3109205	83.4%
/	375648	10.1%
(	114726	3.1%
)	114726	3.1%
-	12064	0.3%
&	2358	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	28311974	99.9%
None	40786	0.1%

Most frequent ASCII characters

Value	Count	Frequency (%)
e	3385494	12.0%
	3109205	11.0%
r	2064180	7.3%
a	1857764	6.6%
i	1740712	6.1%
l	1695737	6.0%
A	1611741	5.7%
n	1489042	5.3%
m	1045719	3.7%
t	1009376	3.6%
c	916530	3.2%
o	857023	3.0%
u	669988	2.4%
P	630283	2.2%
g	514774	1.8%
I	464670	1.6%
S	444824	1.6%
s	424335	1.5%
b	420790	1.5%
B	385738	1.4%
/	375648	1.3%
p	344643	1.2%
h	285034	1.0%
D	268623	0.9%
d	264957	0.9%
Other values (30)	2035144	7.2%

Most frequent None characters

Value	Count	Frequency (%)
ä	23523	57.7%
è	8821	21.6%
ö	8442	20.7%

review_palate
Real number (ℝ_≥0)

Distinct count	9
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.7437013665579655
Minimum	1.0
Maximum	5.0
Zeros	0
Zeros (%)	0.0%
Memory size	12.1 MiB

Quantile statistics

Minimum	1
5-th percentile	2.5
Q1	3.5
median	4
Q3	4
95-th percentile	4.5
Maximum	5
Range	4
Interquartile range (IQR)	0.5

Descriptive statistics

Standard deviation	0.6822183634
Coefficient of variation (CV)	0.1822309785
Kurtosis	1.303397287
Mean	3.743701367
Median Absolute Deviation (MAD)	0.5
Skewness	-0.8691499712
Sum	5939809
Variance	0.4654218953

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4	606711	38.2%
3.5	338585	21.3%
4.5	253102	16.0%
3	206932	13.0%
2.5	62842	4.0%
5	62190	3.9%
2	38333	2.4%
1.5	11045	0.7%
1	6874	0.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	6874	0.4%
1.5	11045	0.7%
2	38333	2.4%
2.5	62842	4.0%
3	206932	13.0%
3.5	338585	21.3%
4	606711	38.2%
4.5	253102	16.0%
5	62190	3.9%

Value	Count	Frequency (%)
5	62190	3.9%
4.5	253102	16.0%
4	606711	38.2%
3.5	338585	21.3%
3	206932	13.0%
2.5	62842	4.0%
2	38333	2.4%
1.5	11045	0.7%
1	6874	0.4%

review_taste
Real number (ℝ_≥0)

Distinct count	9
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.792860456292457
Minimum	1.0
Maximum	5.0
Zeros	0
Zeros (%)	0.0%
Memory size	12.1 MiB

Quantile statistics

Minimum	1
5-th percentile	2.5
Q1	3.5
median	4
Q3	4.5
95-th percentile	5
Maximum	5
Range	4
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.7319696099
Coefficient of variation (CV)	0.1929861692
Kurtosis	1.341669306
Mean	3.792860456
Median Absolute Deviation (MAD)	0.5
Skewness	-0.9734324438
Sum	6017805.5
Variance	0.5357795098

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4	541429	34.1%
4.5	336162	21.2%
3.5	324541	20.5%
3	166860	10.5%
5	83977	5.3%
2.5	66534	4.2%
2	41992	2.6%
1.5	15128	1.0%
1	9991	0.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	9991	0.6%
1.5	15128	1.0%
2	41992	2.6%
2.5	66534	4.2%
3	166860	10.5%
3.5	324541	20.5%
4	541429	34.1%
4.5	336162	21.2%
5	83977	5.3%

Value	Count	Frequency (%)
5	83977	5.3%
4.5	336162	21.2%
4	541429	34.1%
3.5	324541	20.5%
3	166860	10.5%
2.5	66534	4.2%
2	41992	2.6%
1.5	15128	1.0%
1	9991	0.6%

beer_name
Categorical

HIGH CARDINALITY

Distinct count	56857
Unique (%)	3.6%
Missing	0
Missing (%)	0.0%
Memory size	12.1 MiB

90 Minute IPA	3290
India Pale Ale	3130
Old Rasputin Russian Imperial Stout	3111
Sierra Nevada Celebration Ale	3000
Two Hearted Ale	2728
Other values (56852)	1571355

Value	Count	Frequency (%)
90 Minute IPA	3290	0.2%
India Pale Ale	3130	0.2%
Old Rasputin Russian Imperial Stout	3111	0.2%
Sierra Nevada Celebration Ale	3000	0.2%
Two Hearted Ale	2728	0.2%
Arrogant Bastard Ale	2704	0.2%
Stone Ruination IPA	2704	0.2%
Sierra Nevada Pale Ale	2587	0.2%
Stone IPA (India Pale Ale)	2575	0.2%
Pliny The Elder	2527	0.2%
Founders Breakfast Stout	2502	0.2%
Pale Ale	2500	0.2%
Sierra Nevada Bigfoot Barleywine Style Ale	2492	0.2%
La Fin Du Monde	2483	0.2%
60 Minute IPA	2475	0.2%
Storm King Stout	2452	0.2%
Duvel	2450	0.2%
Brooklyn Black Chocolate Stout	2447	0.2%
Bell's Hopslam Ale	2443	0.2%
Samuel Adams Boston Lager	2418	0.2%
Stone Imperial Russian Stout	2329	0.1%
HopDevil Ale	2302	0.1%
Chocolate Stout	2292	0.1%
Imperial Stout	2273	0.1%
Young's Double Chocolate Stout	2257	0.1%
Other values (56832)	1522143	95.9%

Length

Max length	75
Median length	19
Mean length	20.45317513
Min length	1

Overview of Unicode Properties

Unique unicode characters	190
Unique unicode categories (?)	19
Unique unicode scripts (?)	5
Unique unicode blocks (?)	6

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
	3545473	10.9%
e	3527081	10.9%
a	2055389	6.3%
r	2035112	6.3%
l	1817251	5.6%
o	1602495	4.9%
i	1550559	4.8%
t	1540208	4.7%
n	1393651	4.3%
s	1087452	3.4%
u	892827	2.8%
A	771599	2.4%
S	663609	2.0%
d	656780	2.0%
m	598820	1.8%
h	579255	1.8%
B	568115	1.8%
c	512267	1.6%
P	469612	1.4%
p	465701	1.4%
g	434248	1.3%
k	392683	1.2%
b	347973	1.1%
y	330369	1.0%
I	292613	0.9%
Other values (165)	4320152	13.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	22576298	69.6%
Uppercase Letter	5373685	16.6%
Space Separator	3545492	10.9%
Decimal Number	337678	1.0%
Other Punctuation	294036	0.9%
Close Punctuation	111939	0.3%
Open Punctuation	111937	0.3%
Dash Punctuation	95525	0.3%
Other Symbol	2455	< 0.1%
Control	959	< 0.1%
Math Symbol	545	< 0.1%
Other Letter	266	< 0.1%
Final Punctuation	235	< 0.1%
Other Number	174	< 0.1%
Currency Symbol	44	< 0.1%
Modifier Symbol	11	< 0.1%
Modifier Letter	8	< 0.1%
Initial Punctuation	6	< 0.1%
Format	1	< 0.1%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
A	771599	14.4%
S	663609	12.3%
B	568115	10.6%
P	469612	8.7%
I	292613	5.4%
D	253528	4.7%
H	246781	4.6%
C	243799	4.5%
W	200696	3.7%
L	198630	3.7%
R	194597	3.6%
T	193540	3.6%
O	183733	3.4%
M	173028	3.2%
F	141195	2.6%
G	129952	2.4%
E	105001	2.0%
N	96574	1.8%
K	73455	1.4%
J	44627	0.8%
V	38707	0.7%
U	28180	0.5%
Y	23480	0.4%
X	18787	0.3%
Q	7491	0.1%
Other values (25)	12356	0.2%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
e	3527081	15.6%
a	2055389	9.1%
r	2035112	9.0%
l	1817251	8.0%
o	1602495	7.1%
i	1550559	6.9%
t	1540208	6.8%
n	1393651	6.2%
s	1087452	4.8%
u	892827	4.0%
d	656780	2.9%
m	598820	2.7%
h	579255	2.6%
c	512267	2.3%
p	465701	2.1%
g	434248	1.9%
k	392683	1.7%
b	347973	1.5%
y	330369	1.5%
w	178190	0.8%
v	177629	0.8%
f	173391	0.8%
z	78901	0.3%
x	43958	0.2%
é	19550	0.1%
Other values (43)	84558	0.4%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	3545473	> 99.9%
	19	< 0.1%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
0	100405	29.7%
1	63830	18.9%
2	49056	14.5%
8	22544	6.7%
5	21438	6.3%
9	19902	5.9%
3	18320	5.4%
4	15604	4.6%
6	14188	4.2%
7	12391	3.7%

Most frequent Open Punctuation characters

Value	Count	Frequency (%)
(	111407	99.5%
[	530	0.5%

Most frequent Close Punctuation characters

Value	Count	Frequency (%)
)	111409	99.5%
]	530	0.5%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
'	171493	58.3%
.	63173	21.5%
#	14162	4.8%
&	12314	4.2%
/	11932	4.1%
"	6479	2.2%
,	4149	1.4%
:	3078	1.0%
!	2870	1.0%
%	2537	0.9%
*	594	0.2%
?	449	0.2%
;	399	0.1%
§	384	0.1%
¿	23	< 0.1%

Most frequent Dash Punctuation characters

Value	Count	Frequency (%)
-	95519	> 99.9%
–	6	< 0.1%

Most frequent Initial Punctuation characters

Value	Count	Frequency (%)
“	3	50.0%
‘	2	33.3%
«	1	16.7%

Most frequent Other Symbol characters

Value	Count	Frequency (%)
°	2455	100.0%

Most frequent Control characters

Value	Count	Frequency (%)
	362	37.7%
	316	33.0%
	154	16.1%
	98	10.2%
	18	1.9%
	6	0.6%
	3	0.3%
	2	0.2%

Most frequent Final Punctuation characters

Value	Count	Frequency (%)
’	231	98.3%
”	3	1.3%
»	1	0.4%

Most frequent Math Symbol characters

Value	Count	Frequency (%)
+	539	98.9%
=	4	0.7%
~	2	0.4%

Most frequent Other Letter characters

Value	Count	Frequency (%)
黑	229	86.1%
º	26	9.8%
ビ	2	0.8%
葉	1	0.4%
山	1	0.4%
ル	1	0.4%
横	1	0.4%
須	1	0.4%
賀	1	0.4%
ア	1	0.4%
サ	1	0.4%
ケ	1	0.4%

Most frequent Modifier Symbol characters

Value	Count	Frequency (%)
´	10	90.9%
^	1	9.1%

Most frequent Other Number characters

Value	Count	Frequency (%)
³	138	79.3%
½	35	20.1%
²	1	0.6%

Most frequent Modifier Letter characters

Value	Count	Frequency (%)
ʼ	7	87.5%
ー	1	12.5%

Most frequent Currency Symbol characters

Value	Count	Frequency (%)
$	44	100.0%

Most frequent Format characters

Value	Count	Frequency (%)
‏	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	27950006	86.1%
Common	4501045	13.9%
Han	234	< 0.1%
Katakana	6	< 0.1%
Greek	3	< 0.1%

Most frequent Latin characters

Value	Count	Frequency (%)
e	3527081	12.6%
a	2055389	7.4%
r	2035112	7.3%
l	1817251	6.5%
o	1602495	5.7%
i	1550559	5.5%
t	1540208	5.5%
n	1393651	5.0%
s	1087452	3.9%
u	892827	3.2%
A	771599	2.8%
S	663609	2.4%
d	656780	2.3%
m	598820	2.1%
h	579255	2.1%
B	568115	2.0%
c	512267	1.8%
P	469612	1.7%
p	465701	1.7%
g	434248	1.6%
k	392683	1.4%
b	347973	1.2%
y	330369	1.2%
I	292613	1.0%
D	253528	0.9%
Other values (93)	3110809	11.1%

Most frequent Common characters

Value	Count	Frequency (%)
	3545473	78.8%
'	171493	3.8%
)	111409	2.5%
(	111407	2.5%
0	100405	2.2%
-	95519	2.1%
1	63830	1.4%
.	63173	1.4%
2	49056	1.1%
8	22544	0.5%
5	21438	0.5%
9	19902	0.4%
3	18320	0.4%
4	15604	0.3%
6	14188	0.3%
#	14162	0.3%
7	12391	0.3%
&	12314	0.3%
/	11932	0.3%
"	6479	0.1%
,	4149	0.1%
:	3078	0.1%
!	2870	0.1%
%	2537	0.1%
°	2455	0.1%
Other values (35)	4917	0.1%

Most frequent Han characters

Value	Count	Frequency (%)
黑	229	97.9%
葉	1	0.4%
山	1	0.4%
横	1	0.4%
須	1	0.4%
賀	1	0.4%

Most frequent Katakana characters

Value	Count	Frequency (%)
ビ	2	33.3%
ル	1	16.7%
ア	1	16.7%
サ	1	16.7%
ケ	1	16.7%

Most frequent Greek characters

Value	Count	Frequency (%)
Ω	3	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	32366038	99.7%
None	84762	0.3%
Punctuation	246	< 0.1%
CJK	234	< 0.1%
Katakana	7	< 0.1%
Modifier Letters	7	< 0.1%

Most frequent ASCII characters

Value	Count	Frequency (%)
	3545473	11.0%
e	3527081	10.9%
a	2055389	6.4%
r	2035112	6.3%
l	1817251	5.6%
o	1602495	5.0%
i	1550559	4.8%
t	1540208	4.8%
n	1393651	4.3%
s	1087452	3.4%
u	892827	2.8%
A	771599	2.4%
S	663609	2.1%
d	656780	2.0%
m	598820	1.9%
h	579255	1.8%
B	568115	1.8%
c	512267	1.6%
P	469612	1.5%
p	465701	1.4%
g	434248	1.3%
k	392683	1.2%
b	347973	1.1%
y	330369	1.0%
I	292613	0.9%
Other values (61)	4234896	13.1%

Most frequent None characters

Value	Count	Frequency (%)
é	19550	23.1%
ö	14822	17.5%
ä	11881	14.0%
è	7519	8.9%
ü	6147	7.3%
ë	3216	3.8%
ô	3055	3.6%
°	2455	2.9%
É	2306	2.7%
ê	1870	2.2%
Ü	1409	1.7%
ø	1218	1.4%
á	1179	1.4%
å	814	1.0%
í	809	1.0%
Ø	786	0.9%
æ	602	0.7%
ó	437	0.5%
š	421	0.5%
§	384	0.5%
	362	0.4%
ã	330	0.4%
	316	0.4%
ý	301	0.4%
Ô	216	0.3%
Other values (60)	2357	2.8%

Most frequent Punctuation characters

Value	Count	Frequency (%)
’	231	93.9%
–	6	2.4%
“	3	1.2%
”	3	1.2%
‘	2	0.8%
‏	1	0.4%

Most frequent CJK characters

Value	Count	Frequency (%)
黑	229	97.9%
葉	1	0.4%
山	1	0.4%
横	1	0.4%
須	1	0.4%
賀	1	0.4%

Most frequent Katakana characters

Value	Count	Frequency (%)
ビ	2	28.6%
ー	1	14.3%
ル	1	14.3%
ア	1	14.3%
サ	1	14.3%
ケ	1	14.3%

Most frequent Modifier Letters characters

Value	Count	Frequency (%)
ʼ	7	100.0%

beer_abv
Real number (ℝ_≥0)

MISSING

Distinct count	530
Unique (%)	< 0.1%
Missing	67785
Missing (%)	4.3%
Infinite	0
Infinite (%)	0.0%

Mean	7.0423867532158
Minimum	0.01
Maximum	57.7
Zeros	0
Zeros (%)	0.0%
Memory size	12.1 MiB

Quantile statistics

Minimum	0.01
5-th percentile	4.5
Q1	5.2
median	6.5
Q3	8.5
95-th percentile	11
Maximum	57.7
Range	57.69
Interquartile range (IQR)	3.3

Descriptive statistics

Standard deviation	2.322525993
Coefficient of variation (CV)	0.3297924516
Kurtosis	6.961811545
Mean	7.042386753
Median Absolute Deviation (MAD)	1.5
Skewness	1.543406148
Sum	10696181.23
Variance	5.394126987

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
5	109144	6.9%
8	67744	4.3%
6	65383	4.1%
7	59460	3.7%
9	59183	3.7%
5.5	59010	3.7%
10	54780	3.5%
6.5	48369	3.0%
5.2	43268	2.7%
7.5	39978	2.5%
8.5	38474	2.4%
5.4	33123	2.1%
4.9	30914	1.9%
9.5	29999	1.9%
4.5	29358	1.9%
5.3	29085	1.8%
5.6	28913	1.8%
5.8	28571	1.8%
4.8	27097	1.7%
5.1	25122	1.6%
6.2	23587	1.5%
7.2	23540	1.5%
5.9	23232	1.5%
11	23191	1.5%
10.5	21128	1.3%
Other values (505)	497176	31.3%
(Missing)	67785	4.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.01	5	< 0.1%
0.05	17	< 0.1%
0.08	1	< 0.1%
0.1	11	< 0.1%
0.25	3	< 0.1%
0.3	78	< 0.1%
0.4	74	< 0.1%
0.45	55	< 0.1%
0.5	779	< 0.1%
0.7	3	< 0.1%

Value	Count	Frequency (%)
57.7	1	< 0.1%
43	2	< 0.1%
41	76	< 0.1%
39.44	3	< 0.1%
39	7	< 0.1%
32	88	< 0.1%
30.86	1	< 0.1%
29	16	< 0.1%
28	3	< 0.1%
27	355	< 0.1%

beer_beerid
Real number (ℝ_≥0)

Distinct count	66055
Unique (%)	4.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	21712.79427888573
Minimum	3
Maximum	77317
Zeros	0
Zeros (%)	0.0%
Memory size	12.1 MiB

Quantile statistics

Minimum	3
5-th percentile	213
Q1	1717
median	13906
Q3	39441
95-th percentile	62653
Maximum	77317
Range	77314
Interquartile range (IQR)	37724

Descriptive statistics

Standard deviation	21818.336
Coefficient of variation (CV)	1.004860808
Kurtosis	-0.8339342225
Mean	21712.79428
Median Absolute Deviation (MAD)	13217
Skewness	0.6893969312
Sum	3.444982338e+10
Variance	476039785.7

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2093	3290	0.2%
412	3111	0.2%
1904	3000	0.2%
1093	2728	0.2%
92	2704	0.2%
4083	2704	0.2%
276	2587	0.2%
88	2575	0.2%
7971	2527	0.2%
11757	2502	0.2%
2671	2492	0.2%
34	2483	0.2%
6108	2475	0.2%
1013	2452	0.2%
695	2450	0.2%
680	2447	0.2%
17112	2443	0.2%
104	2418	0.2%
1160	2329	0.1%
1005	2302	0.1%
73	2257	0.1%
355	2234	0.1%
1708	2217	0.1%
754	2210	0.1%
645	2170	0.1%
Other values (66030)	1523507	96.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	3	< 0.1%
4	10	< 0.1%
5	424	< 0.1%
6	877	0.1%
7	659	< 0.1%
8	68	< 0.1%
9	116	< 0.1%
10	717	< 0.1%
11	85	< 0.1%
12	86	< 0.1%

Value	Count	Frequency (%)
77317	1	< 0.1%
77316	1	< 0.1%
77315	1	< 0.1%
77314	1	< 0.1%
77313	1	< 0.1%
77312	1	< 0.1%
77310	1	< 0.1%
77309	1	< 0.1%
77308	1	< 0.1%
77307	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

First rows

	brewery_id	brewery_name	review_time	review_overall	review_aroma	review_appearance	review_profilename	beer_style	review_palate	review_taste	beer_name	beer_abv	beer_beerid
0	10325	Vecchio Birraio	1234817823	1.5	2.0	2.5	stcules	Hefeweizen	1.5	1.5	Sausa Weizen	5.0	47986
1	10325	Vecchio Birraio	1235915097	3.0	2.5	3.0	stcules	English Strong Ale	3.0	3.0	Red Moon	6.2	48213
2	10325	Vecchio Birraio	1235916604	3.0	2.5	3.0	stcules	Foreign / Export Stout	3.0	3.0	Black Horse Black Beer	6.5	48215
3	10325	Vecchio Birraio	1234725145	3.0	3.0	3.5	stcules	German Pilsener	2.5	3.0	Sausa Pils	5.0	47969
4	1075	Caldera Brewing Company	1293735206	4.0	4.5	4.0	johnmichaelsen	American Double / Imperial IPA	4.0	4.5	Cauldron DIPA	7.7	64883
5	1075	Caldera Brewing Company	1325524659	3.0	3.5	3.5	oline73	Herbed / Spiced Beer	3.0	3.5	Caldera Ginger Beer	4.7	52159
6	1075	Caldera Brewing Company	1318991115	3.5	3.5	3.5	Reidrover	Herbed / Spiced Beer	4.0	4.0	Caldera Ginger Beer	4.7	52159
7	1075	Caldera Brewing Company	1306276018	3.0	2.5	3.5	alpinebryant	Herbed / Spiced Beer	2.0	3.5	Caldera Ginger Beer	4.7	52159
8	1075	Caldera Brewing Company	1290454503	4.0	3.0	3.5	LordAdmNelson	Herbed / Spiced Beer	3.5	4.0	Caldera Ginger Beer	4.7	52159
9	1075	Caldera Brewing Company	1285632924	4.5	3.5	5.0	augustgarage	Herbed / Spiced Beer	4.0	4.0	Caldera Ginger Beer	4.7	52159

Last rows

	brewery_id	brewery_name	review_time	review_overall	review_aroma	review_appearance	review_profilename	beer_style	review_palate	review_taste	beer_name	beer_abv	beer_beerid
1586604	14359	The Defiant Brewing Company	1288890206	4.0	4.5	4.5	njmoons	Pumpkin Ale	3.5	3.5	The Horseman's Ale	5.2	33061
1586605	14359	The Defiant Brewing Company	1163291143	5.0	5.0	5.0	NyackNicky	Pumpkin Ale	5.0	5.0	The Horseman's Ale	5.2	33061
1586606	14359	The Defiant Brewing Company	1162871808	5.0	4.5	4.0	blitheringidiot	Pumpkin Ale	5.0	5.0	The Horseman's Ale	5.2	33061
1586607	14359	The Defiant Brewing Company	1162865640	5.0	5.0	4.5	PopeDX	Pumpkin Ale	5.0	4.5	The Horseman's Ale	5.2	33061
1586608	14359	The Defiant Brewing Company	1162685856	3.5	4.0	4.0	treehugger02010	Pumpkin Ale	3.5	3.0	The Horseman's Ale	5.2	33061
1586609	14359	The Defiant Brewing Company	1162684892	5.0	4.0	3.5	maddogruss	Pumpkin Ale	4.0	4.0	The Horseman's Ale	5.2	33061
1586610	14359	The Defiant Brewing Company	1161048566	4.0	5.0	2.5	yelterdow	Pumpkin Ale	2.0	4.0	The Horseman's Ale	5.2	33061
1586611	14359	The Defiant Brewing Company	1160702513	4.5	3.5	3.0	TongoRad	Pumpkin Ale	3.5	4.0	The Horseman's Ale	5.2	33061
1586612	14359	The Defiant Brewing Company	1160023044	4.0	4.5	4.5	dherling	Pumpkin Ale	4.5	4.5	The Horseman's Ale	5.2	33061
1586613	14359	The Defiant Brewing Company	1160005319	5.0	4.5	4.5	cbl2	Pumpkin Ale	4.5	4.5	The Horseman's Ale	5.2	33061

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent Uppercase Letter characters

Most frequent Lowercase Letter characters

Most frequent Space Separator characters

Most frequent Other Punctuation characters

Most frequent Decimal Number characters

Most frequent Dash Punctuation characters

Most frequent Open Punctuation characters

Most frequent Close Punctuation characters

Most frequent Control characters

Most frequent Modifier Symbol characters

Most frequent Final Punctuation characters

Most frequent Math Symbol characters

Most occurring scripts

Most frequent Latin characters

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Most frequent None characters

Most frequent Punctuation characters

Most occurring characters

Most occurring categories

Most frequent Lowercase Letter characters

Most frequent Decimal Number characters

Most frequent Uppercase Letter characters

Most frequent Other Punctuation characters

Most occurring scripts

Most frequent Latin characters

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Uppercase Letter characters

Most frequent Lowercase Letter characters

Most frequent Space Separator characters

Most frequent Other Punctuation characters

Most frequent Open Punctuation characters

Most frequent Close Punctuation characters

Most frequent Dash Punctuation characters

Most occurring scripts

Most frequent Latin characters

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Most frequent None characters

Most occurring characters

Most occurring categories

Most frequent Uppercase Letter characters

Most frequent Lowercase Letter characters

Most frequent Space Separator characters

Most frequent Decimal Number characters

Most frequent Open Punctuation characters

Most frequent Close Punctuation characters

Most frequent Other Punctuation characters

Most frequent Dash Punctuation characters

Most frequent Initial Punctuation characters

Most frequent Other Symbol characters

Most frequent Control characters

Most frequent Final Punctuation characters

Most frequent Math Symbol characters

Most frequent Other Letter characters

Most frequent Modifier Symbol characters

Most frequent Other Number characters

Most frequent Modifier Letter characters

Most frequent Currency Symbol characters

Most frequent Format characters

Most occurring scripts

Most frequent Latin characters

Most frequent Common characters

Most frequent Han characters

Most frequent Katakana characters

Most frequent Greek characters

Most occurring blocks

Most frequent ASCII characters

Most frequent None characters

Most frequent Punctuation characters